import datetime
from applications.extensions import db

class CompanyJob(db.Model):
    __tablename__ = 'company_job_tb'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), comment='隶属的企业')
    jobname = db.Column(db.String(20), comment='职位名称')
    salary = db.Column(db.String(20), comment='薪资')
    city = db.Column(db.String(20), comment='城市')
    status = db.Column(db.String(20), comment='审核状态')
    education = db.Column(db.String(20), comment='学历')
    company = db.Column(db.String(20), comment='公司')
    jobdesc = db.Column(db.Text, comment='职位描述')
    create_time = db.Column(db.DateTime, default=datetime.datetime.now)

